Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Building and Maintaining Analytic Workspaces

The `DBMS_AWM` package manages the life cycle of standard form analytic workspaces. This includes the creation of workspace cubes from relational sources, data loads, and the enablement of workspace cubes for relational access.

The `DBMS_AWM` package stores information about workspace builds in the OLAP Catalog. You can query the Analytic Workspace Maintenance views to obtain this information. For example, you could obtain a list of workspace cubes with their relational sources, a list of load specifications, or a list of composite specifications.

The `DBMS_AWM` package stores information about workspace enablement within the analytic workspace itself. The Analytic Workspace Maintenance views use `OLAP_TABLE` functions to return information about the enablement of workspace cubes. You can query these views to obtain the names of enablement views and hierarchy combinations.